Hệ thống hiệu sách thương mại điện tử
1 <?php
2 session_start();
3 if(!isset($_SESSION['user']))
4 header("location: index.php?Message=Login To Continue");
5 ?>
6
7 <!DOCTYPE html>
8 <html lang="en">
9 <head>
10
11 <meta charset="utf-8">
12 <meta http-equiv="X-UA-Compatible" content="IE=edge">
13 <meta name="viewport" content="width=device-width, initial-scale=1">
14 <meta name="description" content="Books">
15 <meta name="author" content="Shivangi Gupta">
16 <title>Online Bookstore</title>
17 <!-- Bootstrap -->
18 <link href="css/bootstrap.min.css" rel="stylesheet">
19 <link href="css/my.css" rel="stylesheet">
20
21 <style>
22
23 #books {margin-bottom:50px;}
24
25 @media only screen and (width: 767px) { body{margin-top:150px;}}
26 #books .row{margin-top:20px;margin-bottom:10px;font-weight:800;}
27 @media only screen and (max-width: 760px) { #books .row{margin-top:10px;}}
28 </style>
29
30 </head>
31 <body>
32
33 <nav class="navbar navbar-default navbar-fixed-top navbar-inverse">
34 <div class="container-fluid">
35 <!-- Brand and toggle get grouped for better mobile display -->
36 <div class="navbar-header">
37 <button type="button" class="navbar-toggle collapsed" data-toggle="collapse" data-target="#bs-example-navbar-collapse-1" aria-expanded="false">
38 <span class="sr-only">Toggle navigation</span>
39 <span class="icon-bar"></span>
40 <span class="icon-bar"></span>
41 <span class="icon-bar"></span>
42 </button>
43 <a class="navbar-brand" href="index.php"><img alt="Brand" src="img/logo.jpg" style="width: 118px;margin-top: -7px;margin-left: -10px;"></a>
44 </div>
45
46 <!-- Collect the nav links, forms, and other content for toggling -->
47 <div class="collapse navbar-collapse" id="bs-example-navbar-collapse-1">
48 <ul class="nav navbar-nav navbar-right">
49 <?php
50 if(isset($_SESSION['user']))
51 {
52 echo'
53 <li><a href="cart.php" class="btn btn-md"><span class="glyphicon glyphicon-shopping-cart">Cart</span></a></li>
54 <li><a href="destroy.php" class="btn btn-md"> <span class="glyphicon glyphicon-log-out">LogOut</span></a></li>
55 ';
56 }
57 ?>
58 </ul>
59 </div><!-- /.navbar-collapse -->
60 </div><!-- /.container-fluid -->
61 </nav>
62
63 <div id="top" >
64 <div id="searchbox" class="container-fluid" style="width:112%;margin-left:-6%;margin-right:-6%;">
65 <div>
66 <form role="search" action="Result.php" method="post">
67 <input type="text" name="keyword" class="form-control" placeholder="Search for a Book , Author Or Category" style="width:80%;margin:20px 10% 20px 10%;">
68 </form>
69 </div>
70 </div>
71
72 <?php
73 include "dbconnect.php";
74 if(isset($_GET['value']))
75 {
76 $_SESSION['category']=$_GET['value'];
77 }
78 $category=$_SESSION['category'];
79 if(isset($_POST['sort']))
80 {
81 if($_POST['sort']=="price")
82 { $query = "SELECT * FROM products WHERE Category='$category' ORDER BY Price";
83 $result = mysqli_query ($con,$query)or die(mysqli_error($con));
84 ?>
85 <script type="text/javascript">
86 document.getElementById('select').Selected=$_POST['sort'];
87 </script>
88 <?php
89 }
90 else
91 if($_POST['sort']=="priceh")
92 { $query = "SELECT * FROM products WHERE Category='$category' ORDER BY Price DESC";
93 $result = mysqli_query ($con,$query)or die(mysqli_error($con));
94 }
95 else
96 if($_POST['sort']=="discount")
97 { $query = "SELECT * FROM products WHERE Category='$category' ORDER BY Discount DESC";
98 $result = mysqli_query ($con,$query)or die(mysqli_error($con));
99 }
100 else
101 if($_POST['sort']=="discountl")
102 { $query = "SELECT * FROM products WHERE Category='$category' ORDER BY Discount";
103 $result = mysqli_query ($con,$query)or die(mysqli_error($con));
104 }
105 }
106 else
107 { $query = "SELECT * FROM products WHERE Category='$category'";
108 $result = mysqli_query ($con,$query)or die(mysqli_error($con));
109 }
110 $i=0;
111 echo '<div class="container-fluid" id="books">
112 <div class="row">
113 <div class="col-xs-12 text-center" id="heading">
114 <h2 style="color:rgb(228, 55, 25);text-transform:uppercase;margin-bottom:0px;"> '. $category .' STORE </h2>
115 </div>
116 </div>
117 <div class="container fluid">
118 <div class="row">
119 <div class="col-sm-5 col-sm-offset-6 col-md-5 col-md-offset-7 col-lg-4 col-lg-offset-8">
120 <form action="';echo $_SERVER['PHP_SELF'];echo'" method="post" class="pull-right">
121 <label for="sort">Sort by  :  </label>
122 <select name="sort" id="select" onchange="form.submit()">
123 <option value="default" name="default" selected="selected">Select</option>
124 <option value="price" name="price">Low To High Price </option>
125 <option value="priceh" name="priceh">Highest To Lowest Price </option>
126 <option value="discountl" name="discountl">Low To High Discount </option>
127 <option value="discount" name="discount">Highest To Lowest Discount</option>
128 </select>
129 </form>
130 </div>
131 </div>
132 </div>';
133
134 if(mysqli_num_rows($result) > 0)
135 {
136 while($row = mysqli_fetch_assoc($result))
137 {
138 $path="img/books/" .$row['PID'].".jpg";
139 $description="description.php?ID=".$row["PID"];
140 if($i%4==0)
141 echo '<div class="row">';
142 echo'
143 <a href="'.$description.'">
144 <div class="col-sm-6 col-md-3 col-lg-3 text-center">
145 <div class="book-block" style="border :3px solid #DEEAEE;">
146 <img class="book block-center img-responsive" src="'.$path.'">
147 <hr>
148 ' . $row["Title"] . '<br>
149 ' . $row["Price"] .'  
150 <span style="text-decoration:line-through;color:#828282;"> ' . $row["MRP"] .' </span>
151 <span class="label label-warning">'. $row["Discount"] .'%</span>
152 </div>
153 </div>
154
155 </a> ';
156 $i++;
157 if($i%4==0)
158 echo '</div>';
159 }
160 }
161 echo '</div>';
162 ?>
163
164
165
166 <!-- jQuery (necessary for Bootstrap's JavaScript plugins) -->
167 <script src="https://ajax.googleapis.com/ajax/libs/jquery/1.11.3/jquery.min.js"></script>
168 <!-- Include all compiled plugins (below), or include individual files as needed -->
169 <script src="js/bootstrap.min.js"></script>
170 </body>
171 </html>
172 <!--
173 <script>
174 $('#my_select').change(function() {
175 // assign the value to a variable, so you can test to see if it is working
176 var selectVal = $('#my_select :selected').val();
177 alert(selectVal);
178 });
179 </script>
180
181 -->